{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='驭胜')|(price['brand']=='陆风')|(price['brand']=='福特')|(price['brand']=='北汽昌河')|(price['brand']=='长安汽车')|(price['brand']=='铃木')|(price['brand']=='江铃')|(price['brand']=='长安欧尚')|(price['brand']=='长安跨越')|(price['brand']=='长安轻型车')]\n",
    "\n",
    "LSG_price = LSG_price[LSG_price['factory']!='进口福特>>']\n",
    "LSG_price = LSG_price[LSG_price['factory']!='进口福特新能源>>']\n",
    "LSG_price = LSG_price[LSG_price['factory']!='进口铃木>>']\n",
    "LSG_price = LSG_price[LSG_price['factory']!='铃木']\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['北汽昌河>>', '北汽昌河新能源>>', '长安欧尚', '长安轻型车', '长安跨越', '长安福特>>', '进口福特>>',\n",
       "       '江铃福特>>', '长安福特新能源>>', '进口福特新能源>>', '江铃汽车>>', '江铃旅居车>>', '江铃轻汽>>',\n",
       "       '江铃新能源>>', '长安铃木>>', '进口铃木>>', '昌河铃木>>', '长安汽车>>', '长安新能源>>',\n",
       "       '江铃汽车', '长安铃木', '铃木', '昌河铃木'], dtype=object)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price.factory.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','style','brand'])['factory'].count().reset_index().to_csv('temp1.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='LKC')|(all1['3']=='LKE')|(all1['3']=='LS4')|(all1['3']=='LS5')|(all1['3']=='LVF')|(all1['3']=='LVR')|(all1['3']=='LVS')|(all1['3']=='LVX')|(all1['3']=='LEF')|(all1['3']=='LF0')|(all1['3']=='LJX')|(all1['3']=='LNB')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CAF7200A62</td>\n",
       "      <td>福特</td>\n",
       "      <td>1659</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1999</td>\n",
       "      <td>174</td>\n",
       "      <td>LVSHFFAC×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>CAF7200A62</td>\n",
       "      <td>福特</td>\n",
       "      <td>1659</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1999</td>\n",
       "      <td>174</td>\n",
       "      <td>LVSHFFAC×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧 插电混动</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>CAF7200A61</td>\n",
       "      <td>福特</td>\n",
       "      <td>1625</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1999</td>\n",
       "      <td>152</td>\n",
       "      <td>LVSHFFAC×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>CAF7200A61</td>\n",
       "      <td>福特</td>\n",
       "      <td>1625</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1999</td>\n",
       "      <td>152</td>\n",
       "      <td>LVSHFFAC×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧 插电混动</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>CAF7153A5</td>\n",
       "      <td>福特</td>\n",
       "      <td>1561,1608</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1499</td>\n",
       "      <td>135</td>\n",
       "      <td>LVSHFFAL×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>CAF7153A5</td>\n",
       "      <td>福特</td>\n",
       "      <td>1561,1608</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1499</td>\n",
       "      <td>135</td>\n",
       "      <td>LVSHFFAL×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧 插电混动</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>CAF7200A52</td>\n",
       "      <td>福特</td>\n",
       "      <td>1659</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1999</td>\n",
       "      <td>182</td>\n",
       "      <td>LVSHFFAC×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>CAF7200A52</td>\n",
       "      <td>福特</td>\n",
       "      <td>1659</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1999</td>\n",
       "      <td>182</td>\n",
       "      <td>LVSHFFAC×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧 插电混动</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>CAF7200A51</td>\n",
       "      <td>福特</td>\n",
       "      <td>1625</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1999</td>\n",
       "      <td>152</td>\n",
       "      <td>LVSHFFAC×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>CAF7200A51</td>\n",
       "      <td>福特</td>\n",
       "      <td>1625</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1999</td>\n",
       "      <td>152</td>\n",
       "      <td>LVSHFFAC×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧 插电混动</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>CAF7153A5</td>\n",
       "      <td>福特</td>\n",
       "      <td>1561,1608</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1499</td>\n",
       "      <td>135</td>\n",
       "      <td>LVSHFFAL×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>CAF7153A5</td>\n",
       "      <td>福特</td>\n",
       "      <td>1561,1608</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1499</td>\n",
       "      <td>135</td>\n",
       "      <td>LVSHFFAL×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧 插电混动</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>CAF7200A51</td>\n",
       "      <td>福特</td>\n",
       "      <td>1625</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1999</td>\n",
       "      <td>152</td>\n",
       "      <td>LVSHFFAC×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>CAF7200A51</td>\n",
       "      <td>福特</td>\n",
       "      <td>1625</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1999</td>\n",
       "      <td>152</td>\n",
       "      <td>LVSHFFAC×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧 插电混动</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>CAF7200A51</td>\n",
       "      <td>福特</td>\n",
       "      <td>1625</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1999</td>\n",
       "      <td>152</td>\n",
       "      <td>LVSHFFAC×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>CAF7200A51</td>\n",
       "      <td>福特</td>\n",
       "      <td>1625</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1999</td>\n",
       "      <td>152</td>\n",
       "      <td>LVSHFFAC×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧 插电混动</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>CAF7153A5</td>\n",
       "      <td>福特</td>\n",
       "      <td>1561,1608</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1499</td>\n",
       "      <td>135</td>\n",
       "      <td>LVSHFFAL×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>CAF7153A5</td>\n",
       "      <td>福特</td>\n",
       "      <td>1561,1608</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1499</td>\n",
       "      <td>135</td>\n",
       "      <td>LVSHFFAL×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧 插电混动</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>CAF7200A52</td>\n",
       "      <td>福特</td>\n",
       "      <td>1659</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1999</td>\n",
       "      <td>182</td>\n",
       "      <td>LVSHFFAC×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>CAF7200A52</td>\n",
       "      <td>福特</td>\n",
       "      <td>1659</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873</td>\n",
       "      <td>1852</td>\n",
       "      <td>1470</td>\n",
       "      <td>1999</td>\n",
       "      <td>182</td>\n",
       "      <td>LVSHFFAC×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2850</td>\n",
       "      <td>4873x1852x1470</td>\n",
       "      <td>福特</td>\n",
       "      <td>蒙迪欧 插电混动</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>SC7169GBB5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1325</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425</td>\n",
       "      <td>1815</td>\n",
       "      <td>1485</td>\n",
       "      <td>1598</td>\n",
       "      <td>92</td>\n",
       "      <td>LS5A3ABE×××××××××,LS5A3DBE×××××××××</td>\n",
       "      <td>重庆长安汽车股份有限公司</td>\n",
       "      <td>LS5</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425x1815x1485</td>\n",
       "      <td>长安汽车</td>\n",
       "      <td>逸动</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>SC7169JDH5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1360</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425</td>\n",
       "      <td>1815</td>\n",
       "      <td>1485</td>\n",
       "      <td>1598</td>\n",
       "      <td>94</td>\n",
       "      <td>LS5A3DEE×××××××××,LS5A3AEE×××××××××</td>\n",
       "      <td>重庆长安汽车股份有限公司</td>\n",
       "      <td>LS5</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425x1815x1485</td>\n",
       "      <td>长安汽车</td>\n",
       "      <td>逸动</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>SC7169JBH5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1360</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425</td>\n",
       "      <td>1815</td>\n",
       "      <td>1485</td>\n",
       "      <td>1598</td>\n",
       "      <td>94</td>\n",
       "      <td>LS5A3DEE×××××××××</td>\n",
       "      <td>重庆长安汽车股份有限公司</td>\n",
       "      <td>LS5</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425x1815x1485</td>\n",
       "      <td>长安汽车</td>\n",
       "      <td>逸动</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>SC7169JCH5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1330</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425</td>\n",
       "      <td>1815</td>\n",
       "      <td>1485</td>\n",
       "      <td>1598</td>\n",
       "      <td>94</td>\n",
       "      <td>LS5A3DBE×××××××××</td>\n",
       "      <td>重庆长安汽车股份有限公司</td>\n",
       "      <td>LS5</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425x1815x1485</td>\n",
       "      <td>长安汽车</td>\n",
       "      <td>逸动</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>SC7158C5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1380</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425</td>\n",
       "      <td>1815</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>125</td>\n",
       "      <td>LS5A3DEE×××××××××,LS5A3AEE×××××××××</td>\n",
       "      <td>重庆长安汽车股份有限公司</td>\n",
       "      <td>LS5</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425x1815x1485</td>\n",
       "      <td>长安汽车</td>\n",
       "      <td>逸动</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>SC7158CA4</td>\n",
       "      <td>长安</td>\n",
       "      <td>1380</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425</td>\n",
       "      <td>1815</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>125</td>\n",
       "      <td>LS5A3DEE×××××××××,LS5A3AEE×××××××××</td>\n",
       "      <td>重庆长安汽车股份有限公司</td>\n",
       "      <td>LS5</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425x1815x1485</td>\n",
       "      <td>长安汽车</td>\n",
       "      <td>逸动</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>SC7169JAH5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1330</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425</td>\n",
       "      <td>1815</td>\n",
       "      <td>1485</td>\n",
       "      <td>1598</td>\n",
       "      <td>94</td>\n",
       "      <td>LS5A3DBE×××××××××</td>\n",
       "      <td>重庆长安汽车股份有限公司</td>\n",
       "      <td>LS5</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425x1815x1485</td>\n",
       "      <td>长安汽车</td>\n",
       "      <td>逸动</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>SC7169JAH4</td>\n",
       "      <td>长安</td>\n",
       "      <td>1330</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425</td>\n",
       "      <td>1815</td>\n",
       "      <td>1485</td>\n",
       "      <td>1598</td>\n",
       "      <td>94</td>\n",
       "      <td>LS5A3DBE×××××××××</td>\n",
       "      <td>重庆长安汽车股份有限公司</td>\n",
       "      <td>LS5</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425x1815x1485</td>\n",
       "      <td>长安汽车</td>\n",
       "      <td>逸动</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>SC7169GB5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1325</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425</td>\n",
       "      <td>1815</td>\n",
       "      <td>1485</td>\n",
       "      <td>1598</td>\n",
       "      <td>92</td>\n",
       "      <td>LS5A3DBE×××××××××</td>\n",
       "      <td>重庆长安汽车股份有限公司</td>\n",
       "      <td>LS5</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425x1815x1485</td>\n",
       "      <td>长安汽车</td>\n",
       "      <td>逸动</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>SC7158C4</td>\n",
       "      <td>长安</td>\n",
       "      <td>1380</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425</td>\n",
       "      <td>1815</td>\n",
       "      <td>1485</td>\n",
       "      <td>1499</td>\n",
       "      <td>125</td>\n",
       "      <td>LS5A3AEE×××××××××,LS5A3DEE×××××××××</td>\n",
       "      <td>重庆长安汽车股份有限公司</td>\n",
       "      <td>LS5</td>\n",
       "      <td>2660</td>\n",
       "      <td>4425x1815x1485</td>\n",
       "      <td>长安汽车</td>\n",
       "      <td>逸动</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1633</th>\n",
       "      <td>JX6481T4</td>\n",
       "      <td>江铃</td>\n",
       "      <td>2005,2055</td>\n",
       "      <td>2750</td>\n",
       "      <td>4775</td>\n",
       "      <td>1895</td>\n",
       "      <td>1862</td>\n",
       "      <td>2402</td>\n",
       "      <td>103</td>\n",
       "      <td>LEFDJDBB×××××××××</td>\n",
       "      <td>江铃汽车股份有限公司</td>\n",
       "      <td>LEF</td>\n",
       "      <td>2750</td>\n",
       "      <td>4775x1895x1862</td>\n",
       "      <td>驭胜</td>\n",
       "      <td>驭胜S350</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1634</th>\n",
       "      <td>JX6480T4</td>\n",
       "      <td>江铃</td>\n",
       "      <td>1915,1965</td>\n",
       "      <td>2750</td>\n",
       "      <td>4775</td>\n",
       "      <td>1895</td>\n",
       "      <td>1862</td>\n",
       "      <td>2402</td>\n",
       "      <td>103</td>\n",
       "      <td>LEFCJDBB×××××××××</td>\n",
       "      <td>江铃汽车股份有限公司</td>\n",
       "      <td>LEF</td>\n",
       "      <td>2750</td>\n",
       "      <td>4775x1895x1862</td>\n",
       "      <td>驭胜</td>\n",
       "      <td>驭胜S350</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1635</th>\n",
       "      <td>JX6481P4</td>\n",
       "      <td>江铃</td>\n",
       "      <td>1935,1985</td>\n",
       "      <td>2750</td>\n",
       "      <td>4775</td>\n",
       "      <td>1895</td>\n",
       "      <td>1862</td>\n",
       "      <td>1997</td>\n",
       "      <td>140</td>\n",
       "      <td>LEFDJ3BB×××××××××</td>\n",
       "      <td>江铃汽车股份有限公司</td>\n",
       "      <td>LEF</td>\n",
       "      <td>2750</td>\n",
       "      <td>4775x1895x1862</td>\n",
       "      <td>驭胜</td>\n",
       "      <td>驭胜S350</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1636</th>\n",
       "      <td>JX6480P4</td>\n",
       "      <td>江铃</td>\n",
       "      <td>1830,1880</td>\n",
       "      <td>2750</td>\n",
       "      <td>4775</td>\n",
       "      <td>1895</td>\n",
       "      <td>1862</td>\n",
       "      <td>1997</td>\n",
       "      <td>140</td>\n",
       "      <td>LEFCJ3BB×××××××××</td>\n",
       "      <td>江铃汽车股份有限公司</td>\n",
       "      <td>LEF</td>\n",
       "      <td>2750</td>\n",
       "      <td>4775x1895x1862</td>\n",
       "      <td>驭胜</td>\n",
       "      <td>驭胜S350</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1637</th>\n",
       "      <td>JX6480T4</td>\n",
       "      <td>江铃</td>\n",
       "      <td>1915,1965</td>\n",
       "      <td>2750</td>\n",
       "      <td>4775</td>\n",
       "      <td>1895</td>\n",
       "      <td>1862</td>\n",
       "      <td>2402</td>\n",
       "      <td>103</td>\n",
       "      <td>LEFCJDBB×××××××××</td>\n",
       "      <td>江铃汽车股份有限公司</td>\n",
       "      <td>LEF</td>\n",
       "      <td>2750</td>\n",
       "      <td>4775x1895x1862</td>\n",
       "      <td>驭胜</td>\n",
       "      <td>驭胜S350</td>\n",
       "      <td>28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1638</th>\n",
       "      <td>SC6458A4</td>\n",
       "      <td>长安</td>\n",
       "      <td>1295</td>\n",
       "      <td>2680</td>\n",
       "      <td>4465</td>\n",
       "      <td>1725</td>\n",
       "      <td>1685</td>\n",
       "      <td>1498</td>\n",
       "      <td>84</td>\n",
       "      <td>LS4ASM2E×××××××××,LS4ASE2E×××××××××</td>\n",
       "      <td>重庆长安汽车股份有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2680</td>\n",
       "      <td>4465x1725x1685</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>欧尚A600</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1639</th>\n",
       "      <td>SC6406A5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××,LS4AAB2R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1640</th>\n",
       "      <td>SC6406C4</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××,LS4AAB2R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1641</th>\n",
       "      <td>SC6406C5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××,LS4AAB2R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1642</th>\n",
       "      <td>SC6406CV5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××,LS4AAB2R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1643</th>\n",
       "      <td>SC6406AV5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××,LS4AAB2R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1644</th>\n",
       "      <td>SC6406A5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××,LS4AAB2R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1645</th>\n",
       "      <td>SC6406C5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××,LS4AAB2R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1646</th>\n",
       "      <td>SC6406C4</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××,LS4AAB2R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1647</th>\n",
       "      <td>SC6406CV4</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××,LS4AAB2R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1648</th>\n",
       "      <td>SC6406AV5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1649</th>\n",
       "      <td>SC6406A5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1650</th>\n",
       "      <td>SC6406CV5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1651</th>\n",
       "      <td>SC6406C5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1652</th>\n",
       "      <td>SC6406CB5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1653</th>\n",
       "      <td>SC6406C4</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1654</th>\n",
       "      <td>SC6406CV4</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1655</th>\n",
       "      <td>SC6406AYBB5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1656</th>\n",
       "      <td>SC6406CVB5</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1657</th>\n",
       "      <td>SC6406BV4</td>\n",
       "      <td>长安</td>\n",
       "      <td>1110</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>999</td>\n",
       "      <td>50.8</td>\n",
       "      <td>LS4AAB3D×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1658</th>\n",
       "      <td>SC6406B4</td>\n",
       "      <td>长安</td>\n",
       "      <td>1110</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>999</td>\n",
       "      <td>50.8</td>\n",
       "      <td>LS4AAB3D×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1659</th>\n",
       "      <td>SC6406AYA4</td>\n",
       "      <td>长安</td>\n",
       "      <td>1130</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980</td>\n",
       "      <td>1620</td>\n",
       "      <td>1890</td>\n",
       "      <td>1243</td>\n",
       "      <td>72</td>\n",
       "      <td>LS4AAB3R×××××××××</td>\n",
       "      <td>河北长安汽车有限公司</td>\n",
       "      <td>LS4</td>\n",
       "      <td>2560</td>\n",
       "      <td>3980x1620x1890</td>\n",
       "      <td>长安欧尚</td>\n",
       "      <td>长安之星</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1660</th>\n",
       "      <td>CAF6450A41</td>\n",
       "      <td>翼虎(KUGA)</td>\n",
       "      <td>1592</td>\n",
       "      <td>2690</td>\n",
       "      <td>4524</td>\n",
       "      <td>1838</td>\n",
       "      <td>1685</td>\n",
       "      <td>1596</td>\n",
       "      <td>130</td>\n",
       "      <td>LVSHJCAB×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2690</td>\n",
       "      <td>4524x1838x1685</td>\n",
       "      <td>福特</td>\n",
       "      <td>翼虎</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1661</th>\n",
       "      <td>CAF6450A41</td>\n",
       "      <td>翼虎(KUGA)</td>\n",
       "      <td>1592</td>\n",
       "      <td>2690</td>\n",
       "      <td>4524</td>\n",
       "      <td>1838</td>\n",
       "      <td>1685</td>\n",
       "      <td>1598</td>\n",
       "      <td>130</td>\n",
       "      <td>LVSHJCAB×××××××××</td>\n",
       "      <td>长安福特马自达汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2690</td>\n",
       "      <td>4524x1838x1685</td>\n",
       "      <td>福特</td>\n",
       "      <td>翼虎</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1662</th>\n",
       "      <td>CAF6450A41</td>\n",
       "      <td>翼虎(KUGA)</td>\n",
       "      <td>1592</td>\n",
       "      <td>2690</td>\n",
       "      <td>4524</td>\n",
       "      <td>1838</td>\n",
       "      <td>1685</td>\n",
       "      <td>1598</td>\n",
       "      <td>130</td>\n",
       "      <td>LVSHJCAB×××××××××</td>\n",
       "      <td>长安福特汽车有限公司</td>\n",
       "      <td>LVS</td>\n",
       "      <td>2690</td>\n",
       "      <td>4524x1838x1685</td>\n",
       "      <td>福特</td>\n",
       "      <td>翼虎</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1663 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      notice_type   brand_x curb_weight Wheelbase car_length car_width  \\\n",
       "0      CAF7200A62        福特        1659      2850       4873      1852   \n",
       "1      CAF7200A62        福特        1659      2850       4873      1852   \n",
       "2      CAF7200A61        福特        1625      2850       4873      1852   \n",
       "3      CAF7200A61        福特        1625      2850       4873      1852   \n",
       "4       CAF7153A5        福特   1561,1608      2850       4873      1852   \n",
       "5       CAF7153A5        福特   1561,1608      2850       4873      1852   \n",
       "6      CAF7200A52        福特        1659      2850       4873      1852   \n",
       "7      CAF7200A52        福特        1659      2850       4873      1852   \n",
       "8      CAF7200A51        福特        1625      2850       4873      1852   \n",
       "9      CAF7200A51        福特        1625      2850       4873      1852   \n",
       "10      CAF7153A5        福特   1561,1608      2850       4873      1852   \n",
       "11      CAF7153A5        福特   1561,1608      2850       4873      1852   \n",
       "12     CAF7200A51        福特        1625      2850       4873      1852   \n",
       "13     CAF7200A51        福特        1625      2850       4873      1852   \n",
       "14     CAF7200A51        福特        1625      2850       4873      1852   \n",
       "15     CAF7200A51        福特        1625      2850       4873      1852   \n",
       "16      CAF7153A5        福特   1561,1608      2850       4873      1852   \n",
       "17      CAF7153A5        福特   1561,1608      2850       4873      1852   \n",
       "18     CAF7200A52        福特        1659      2850       4873      1852   \n",
       "19     CAF7200A52        福特        1659      2850       4873      1852   \n",
       "20     SC7169GBB5        长安        1325      2660       4425      1815   \n",
       "21     SC7169JDH5        长安        1360      2660       4425      1815   \n",
       "22     SC7169JBH5        长安        1360      2660       4425      1815   \n",
       "23     SC7169JCH5        长安        1330      2660       4425      1815   \n",
       "24       SC7158C5        长安        1380      2660       4425      1815   \n",
       "25      SC7158CA4        长安        1380      2660       4425      1815   \n",
       "26     SC7169JAH5        长安        1330      2660       4425      1815   \n",
       "27     SC7169JAH4        长安        1330      2660       4425      1815   \n",
       "28      SC7169GB5        长安        1325      2660       4425      1815   \n",
       "29       SC7158C4        长安        1380      2660       4425      1815   \n",
       "...           ...       ...         ...       ...        ...       ...   \n",
       "1633     JX6481T4        江铃   2005,2055      2750       4775      1895   \n",
       "1634     JX6480T4        江铃   1915,1965      2750       4775      1895   \n",
       "1635     JX6481P4        江铃   1935,1985      2750       4775      1895   \n",
       "1636     JX6480P4        江铃   1830,1880      2750       4775      1895   \n",
       "1637     JX6480T4        江铃   1915,1965      2750       4775      1895   \n",
       "1638     SC6458A4        长安        1295      2680       4465      1725   \n",
       "1639     SC6406A5        长安        1130      2560       3980      1620   \n",
       "1640     SC6406C4        长安        1130      2560       3980      1620   \n",
       "1641     SC6406C5        长安        1130      2560       3980      1620   \n",
       "1642    SC6406CV5        长安        1130      2560       3980      1620   \n",
       "1643    SC6406AV5        长安        1130      2560       3980      1620   \n",
       "1644     SC6406A5        长安        1130      2560       3980      1620   \n",
       "1645     SC6406C5        长安        1130      2560       3980      1620   \n",
       "1646     SC6406C4        长安        1130      2560       3980      1620   \n",
       "1647    SC6406CV4        长安        1130      2560       3980      1620   \n",
       "1648    SC6406AV5        长安        1130      2560       3980      1620   \n",
       "1649     SC6406A5        长安        1130      2560       3980      1620   \n",
       "1650    SC6406CV5        长安        1130      2560       3980      1620   \n",
       "1651     SC6406C5        长安        1130      2560       3980      1620   \n",
       "1652    SC6406CB5        长安        1130      2560       3980      1620   \n",
       "1653     SC6406C4        长安        1130      2560       3980      1620   \n",
       "1654    SC6406CV4        长安        1130      2560       3980      1620   \n",
       "1655  SC6406AYBB5        长安        1130      2560       3980      1620   \n",
       "1656   SC6406CVB5        长安        1130      2560       3980      1620   \n",
       "1657    SC6406BV4        长安        1110      2560       3980      1620   \n",
       "1658     SC6406B4        长安        1110      2560       3980      1620   \n",
       "1659   SC6406AYA4        长安        1130      2560       3980      1620   \n",
       "1660   CAF6450A41  翼虎(KUGA)        1592      2690       4524      1838   \n",
       "1661   CAF6450A41  翼虎(KUGA)        1592      2690       4524      1838   \n",
       "1662   CAF6450A41  翼虎(KUGA)        1592      2690       4524      1838   \n",
       "\n",
       "     car_height Displacement power                                  vin  \\\n",
       "0          1470         1999   174                    LVSHFFAC×××××××××   \n",
       "1          1470         1999   174                    LVSHFFAC×××××××××   \n",
       "2          1470         1999   152                    LVSHFFAC×××××××××   \n",
       "3          1470         1999   152                    LVSHFFAC×××××××××   \n",
       "4          1470         1499   135                    LVSHFFAL×××××××××   \n",
       "5          1470         1499   135                    LVSHFFAL×××××××××   \n",
       "6          1470         1999   182                    LVSHFFAC×××××××××   \n",
       "7          1470         1999   182                    LVSHFFAC×××××××××   \n",
       "8          1470         1999   152                    LVSHFFAC×××××××××   \n",
       "9          1470         1999   152                    LVSHFFAC×××××××××   \n",
       "10         1470         1499   135                    LVSHFFAL×××××××××   \n",
       "11         1470         1499   135                    LVSHFFAL×××××××××   \n",
       "12         1470         1999   152                    LVSHFFAC×××××××××   \n",
       "13         1470         1999   152                    LVSHFFAC×××××××××   \n",
       "14         1470         1999   152                    LVSHFFAC×××××××××   \n",
       "15         1470         1999   152                    LVSHFFAC×××××××××   \n",
       "16         1470         1499   135                    LVSHFFAL×××××××××   \n",
       "17         1470         1499   135                    LVSHFFAL×××××××××   \n",
       "18         1470         1999   182                    LVSHFFAC×××××××××   \n",
       "19         1470         1999   182                    LVSHFFAC×××××××××   \n",
       "20         1485         1598    92  LS5A3ABE×××××××××,LS5A3DBE×××××××××   \n",
       "21         1485         1598    94  LS5A3DEE×××××××××,LS5A3AEE×××××××××   \n",
       "22         1485         1598    94                    LS5A3DEE×××××××××   \n",
       "23         1485         1598    94                    LS5A3DBE×××××××××   \n",
       "24         1485         1499   125  LS5A3DEE×××××××××,LS5A3AEE×××××××××   \n",
       "25         1485         1499   125  LS5A3DEE×××××××××,LS5A3AEE×××××××××   \n",
       "26         1485         1598    94                    LS5A3DBE×××××××××   \n",
       "27         1485         1598    94                    LS5A3DBE×××××××××   \n",
       "28         1485         1598    92                    LS5A3DBE×××××××××   \n",
       "29         1485         1499   125  LS5A3AEE×××××××××,LS5A3DEE×××××××××   \n",
       "...         ...          ...   ...                                  ...   \n",
       "1633       1862         2402   103                    LEFDJDBB×××××××××   \n",
       "1634       1862         2402   103                    LEFCJDBB×××××××××   \n",
       "1635       1862         1997   140                    LEFDJ3BB×××××××××   \n",
       "1636       1862         1997   140                    LEFCJ3BB×××××××××   \n",
       "1637       1862         2402   103                    LEFCJDBB×××××××××   \n",
       "1638       1685         1498    84  LS4ASM2E×××××××××,LS4ASE2E×××××××××   \n",
       "1639       1890         1243    72  LS4AAB3R×××××××××,LS4AAB2R×××××××××   \n",
       "1640       1890         1243    72  LS4AAB3R×××××××××,LS4AAB2R×××××××××   \n",
       "1641       1890         1243    72  LS4AAB3R×××××××××,LS4AAB2R×××××××××   \n",
       "1642       1890         1243    72  LS4AAB3R×××××××××,LS4AAB2R×××××××××   \n",
       "1643       1890         1243    72  LS4AAB3R×××××××××,LS4AAB2R×××××××××   \n",
       "1644       1890         1243    72  LS4AAB3R×××××××××,LS4AAB2R×××××××××   \n",
       "1645       1890         1243    72  LS4AAB3R×××××××××,LS4AAB2R×××××××××   \n",
       "1646       1890         1243    72  LS4AAB3R×××××××××,LS4AAB2R×××××××××   \n",
       "1647       1890         1243    72  LS4AAB3R×××××××××,LS4AAB2R×××××××××   \n",
       "1648       1890         1243    72                    LS4AAB3R×××××××××   \n",
       "1649       1890         1243    72                    LS4AAB3R×××××××××   \n",
       "1650       1890         1243    72                    LS4AAB3R×××××××××   \n",
       "1651       1890         1243    72                    LS4AAB3R×××××××××   \n",
       "1652       1890         1243    72                    LS4AAB3R×××××××××   \n",
       "1653       1890         1243    72                    LS4AAB3R×××××××××   \n",
       "1654       1890         1243    72                    LS4AAB3R×××××××××   \n",
       "1655       1890         1243    72                    LS4AAB3R×××××××××   \n",
       "1656       1890         1243    72                    LS4AAB3R×××××××××   \n",
       "1657       1890          999  50.8                    LS4AAB3D×××××××××   \n",
       "1658       1890          999  50.8                    LS4AAB3D×××××××××   \n",
       "1659       1890         1243    72                    LS4AAB3R×××××××××   \n",
       "1660       1685         1596   130                    LVSHJCAB×××××××××   \n",
       "1661       1685         1598   130                    LVSHJCAB×××××××××   \n",
       "1662       1685         1598   130                    LVSHJCAB×××××××××   \n",
       "\n",
       "        car_factory    3 轴距[mm]       长×宽×高[mm] brand_y     style  factory  \n",
       "0        长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特       蒙迪欧       20  \n",
       "1        长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特  蒙迪欧 插电混动        3  \n",
       "2        长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特       蒙迪欧       20  \n",
       "3        长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特  蒙迪欧 插电混动        3  \n",
       "4        长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特       蒙迪欧       20  \n",
       "5        长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特  蒙迪欧 插电混动        3  \n",
       "6        长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特       蒙迪欧       20  \n",
       "7        长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特  蒙迪欧 插电混动        3  \n",
       "8        长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特       蒙迪欧       20  \n",
       "9        长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特  蒙迪欧 插电混动        3  \n",
       "10       长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特       蒙迪欧       20  \n",
       "11       长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特  蒙迪欧 插电混动        3  \n",
       "12       长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特       蒙迪欧       20  \n",
       "13       长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特  蒙迪欧 插电混动        3  \n",
       "14       长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特       蒙迪欧       20  \n",
       "15       长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特  蒙迪欧 插电混动        3  \n",
       "16       长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特       蒙迪欧       20  \n",
       "17       长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特  蒙迪欧 插电混动        3  \n",
       "18       长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特       蒙迪欧       20  \n",
       "19       长安福特汽车有限公司  LVS   2850  4873x1852x1470      福特  蒙迪欧 插电混动        3  \n",
       "20     重庆长安汽车股份有限公司  LS5   2660  4425x1815x1485    长安汽车        逸动       28  \n",
       "21     重庆长安汽车股份有限公司  LS5   2660  4425x1815x1485    长安汽车        逸动       28  \n",
       "22     重庆长安汽车股份有限公司  LS5   2660  4425x1815x1485    长安汽车        逸动       28  \n",
       "23     重庆长安汽车股份有限公司  LS5   2660  4425x1815x1485    长安汽车        逸动       28  \n",
       "24     重庆长安汽车股份有限公司  LS5   2660  4425x1815x1485    长安汽车        逸动       28  \n",
       "25     重庆长安汽车股份有限公司  LS5   2660  4425x1815x1485    长安汽车        逸动       28  \n",
       "26     重庆长安汽车股份有限公司  LS5   2660  4425x1815x1485    长安汽车        逸动       28  \n",
       "27     重庆长安汽车股份有限公司  LS5   2660  4425x1815x1485    长安汽车        逸动       28  \n",
       "28     重庆长安汽车股份有限公司  LS5   2660  4425x1815x1485    长安汽车        逸动       28  \n",
       "29     重庆长安汽车股份有限公司  LS5   2660  4425x1815x1485    长安汽车        逸动       28  \n",
       "...             ...  ...    ...             ...     ...       ...      ...  \n",
       "1633     江铃汽车股份有限公司  LEF   2750  4775x1895x1862      驭胜    驭胜S350       28  \n",
       "1634     江铃汽车股份有限公司  LEF   2750  4775x1895x1862      驭胜    驭胜S350       28  \n",
       "1635     江铃汽车股份有限公司  LEF   2750  4775x1895x1862      驭胜    驭胜S350       28  \n",
       "1636     江铃汽车股份有限公司  LEF   2750  4775x1895x1862      驭胜    驭胜S350       28  \n",
       "1637     江铃汽车股份有限公司  LEF   2750  4775x1895x1862      驭胜    驭胜S350       28  \n",
       "1638   重庆长安汽车股份有限公司  LS4   2680  4465x1725x1685    长安欧尚    欧尚A600        2  \n",
       "1639     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1640     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1641     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1642     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1643     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1644     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1645     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1646     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1647     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1648     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1649     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1650     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1651     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1652     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1653     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1654     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1655     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1656     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1657     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1658     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1659     河北长安汽车有限公司  LS4   2560  3980x1620x1890    长安欧尚      长安之星       10  \n",
       "1660     长安福特汽车有限公司  LVS   2690  4524x1838x1685      福特        翼虎        5  \n",
       "1661  长安福特马自达汽车有限公司  LVS   2690  4524x1838x1685      福特        翼虎        5  \n",
       "1662     长安福特汽车有限公司  LVS   2690  4524x1838x1685      福特        翼虎        5  \n",
       "\n",
       "[1663 rows x 17 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('铃木_昌河_福特_江铃_长安.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['福特', '长安汽车', '铃木', '北汽昌河', '江铃', '陆风', '长安欧尚', '长安轻型车', '驭胜'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vin.brand.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
